This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal



Apr 1, 2013, 11:52 AM
8 Posts

Multiple column sorting using Vector on View Panel

  • Category: Server Side JavaScript
  • Platform: Windows
  • Release: 8.5.2
  • Role: Developer
  • Tags: sorting,Vector
  • Replies: 2
I am using vector to create multiple column sorting on a view panel. It is working inconsistently. Sometime it gives no results even I have data matching the search criteria. I am providing my SSJS below. please help me out.

 

Setting variables on search page: 
 
sessionScope.searchfield01 = requestScope.fname;
sessionScope.searchfield02 = requestScope.lname;
sessionScope.searchfield03 = requestScope.email;
sessionScope.searchfield04 = requestScope.country;
sessionScope.searchfield05 = requestScope.company;
 
Using variable on view panel (Computed value for Filter by Column value) to get multi column sorted: 

var vtr:java.util.Vector = new java.util.Vector();
var t1 = sessionScope.searchfield01;
var t2 = sessionScope.searchfield02;
var t3 = sessionScope.searchfield03;
var t4 = sessionScope.searchfield04;
var t5 = sessionScope.searchfield05;

@If(t1 !=null,vtr.addElement(t1),vtr.addElement(""));    
@If(t2 !=null,vtr.addElement(t2),vtr.addElement(""));
@If(t3 !=null,vtr.addElement(t3),vtr.addElement(""));
@If(t4 !=null,vtr.addElement(t4),vtr.addElement(""));
@If(t5 !=null,vtr.addElement(t5),vtr.addElement(""));

return vtr; 

 

Thanks in advance for your kind help. 
Apr 1, 2013, 12:37 PM
366 Posts
Re: Multiple column sorting using Vector on View Panel
 is there a reason you can not use a full text index ?  In 8.5.3 the full text index results are sortable by column.

 
Apr 1, 2013, 1:55 PM
8 Posts
Re: Multiple column sorting using Vector on View Panel
Full text index on 8.5.2?

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal